package com.xiaocikuai.smallchunks.mapper.Transaction;

import com.xiaocikuai.smallchunks.entity.Transaction.RealOrder;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.xiaocikuai.smallchunks.entity.Transaction.RealOrderDTO;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * <p>
 * 实体商品购买管理 Mapper 接口
 * </p>
 *
 * @author author1
 * @since 2024-07-13
 */
public interface RealOrderMapper extends BaseMapper<RealOrder> {

    @Select("SELECT t1.*, t2.*, t3.*\n" +
            "FROM yshop_real_order t1\n" +
            "         JOIN address t2 ON t1.aid = t2.aid\n" +
            "         JOIN product t3 ON t1.pid = t3.pid\n" )
    List<RealOrderDTO>  getListInfo();
}
